Tabela OMCDICTIONARYV002

Definicja tabeli OMCDICTIONARYV002

Name

OMCDICTIONARYV002

Code

OMCDICTIONARYV002

Comment

Klasyfikator profili swiadczenia pomocy medycznej RU


Lista kolumn tabeli OMCDICTIONARYV002

Name

Code

OMCDictionaryV002ID

OMCDictionaryV002ID

Active

Active

Code

Code

Description

Description

FullName

FullName

ShortName

ShortName

CodeOld

CodeOld

StartDT

StartDT

StopDT

StopDT


Kolumna OMCDictionaryV002ID tabeli OMCDICTIONARYV002

Definicja kolumny OMCDictionaryV002ID tabeli OMCDICTIONARYV002

Name

OMCDictionaryV002ID

Code

OMCDictionaryV002ID

Data Type

NUMBER(12)

Mandatory

Yes

Comment

ID klasyfikatora profili swiadczenia pomocy medycznej RU


Kolumna Active tabeli OMCDICTIONARYV002

Definicja kolumny Active tabeli OMCDICTIONARYV002

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

 


Kolumna Code tabeli OMCDICTIONARYV002

Definicja kolumny Code tabeli OMCDICTIONARYV002

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

Kod


Kolumna Description tabeli OMCDICTIONARYV002

Definicja kolumny Description tabeli OMCDICTIONARYV002

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

Opis


Kolumna FullName tabeli OMCDICTIONARYV002

Definicja kolumny FullName tabeli OMCDICTIONARYV002

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Pelna nazwa


Kolumna ShortName tabeli OMCDICTIONARYV002

Definicja kolumny ShortName tabeli OMCDICTIONARYV002

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Krotka nazwa


Kolumna CodeOld tabeli OMCDICTIONARYV002

Definicja kolumny CodeOld tabeli OMCDICTIONARYV002

Name

CodeOld

Code

CodeOld

Data Type

VARCHAR2(13)

Mandatory

No

Comment

Kod nieaktywnego profilu, ktory zostal zastapiony przez ten z tego rekordu


Kolumna StartDT tabeli OMCDICTIONARYV002

Definicja kolumny StartDT tabeli OMCDICTIONARYV002

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku obowiazywania profilu


Kolumna StopDT tabeli OMCDICTIONARYV002

Definicja kolumny StopDT tabeli OMCDICTIONARYV002

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca obowiazywania profilu


Lista kluczy tabeli OMCDICTIONARYV002

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OMCDICTIONARYV002

Definicja klucza Identifier_1 tabeli OMCDICTIONARYV002

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment